-- 敏捷运维通用与基础组件
----记录错误日志
/*==============================================================*/
/* Table: DVP_ERROR_LOG                                         */
/*==============================================================*/

CREATE TABLE ZOEDEVOPS.DVP_ERROR_LOG 
(
   ERROR_NO             NUMBER               DEFAULT ZOEDEVOPS.SEQ_DVP_ERROR_LOG.NEXTVAL NOT NULL,
   ERROR_TYPE           VARCHAR2(64 CHAR),
   ERROR_INFO           VARCHAR2(4000 CHAR)  NOT NULL,
   ERROR_TIME           DATE,
   CONSTRAINT PK_DVP_ERROR_LOG PRIMARY KEY (ERROR_NO),
   CONSTRAINT CJ_DVP_ERROR_LOG CHECK (ERROR_INFO IS JSON(STRICT))
);


COMMENT ON TABLE ZOEDEVOPS.DVP_ERROR_LOG IS '错误日志表';

COMMENT ON COLUMN ZOEDEVOPS.DVP_ERROR_LOG.ERROR_NO IS '错误日志流水号';

COMMENT ON COLUMN ZOEDEVOPS.DVP_ERROR_LOG.ERROR_TYPE IS '错误日志类型';

COMMENT ON COLUMN ZOEDEVOPS.DVP_ERROR_LOG.ERROR_INFO IS '错误日志信息';

COMMENT ON COLUMN ZOEDEVOPS.DVP_ERROR_LOG.ERROR_TIME IS '报错时间';


